﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace EnterpriseFund.BLL
{
    public class SB_ZSXX
    {
        DAL.SB_ZSXX SB_ZSXXDAL = new DAL.SB_ZSXX();

        /// <summary>
        /// 获取Excel中的数据
        /// </summary>
        /// <param name="ExcelFile"></param>
        /// <returns></returns>
        public DataSet ReadExcelTitle(string ExcelFile)
        {
            return SB_ZSXXDAL.ReadExcelTitle(ExcelFile);
        }

        public void ImportData(string strwhere = "1=1", string strwhere2 = "1=1", string orastrwhere = "1=1", string orastrwhere2 = "1=1", int outTimes = 60*60)
        {
            SB_ZSXXDAL.ImportData(strwhere, strwhere2, orastrwhere, orastrwhere2,outTimes);
        }

        public DataSet GetAddCredits(string strWhere1)
        {
            return SB_ZSXXDAL.GetAddCredits(strWhere1);
        }
        public DataTable  GetZZSYDB(string dtime,string strWhere)
        {
            return SB_ZSXXDAL.GetZZSYDB(dtime, strWhere).Tables[0];
        }
        public DataTable GetQueryTB(string dtime, string strWhere)
        {
            return SB_ZSXXDAL.GetQueryTB(dtime, strWhere).Tables[0];
        }
        public DataTable GetQueryZD(string dtime, string strWhere)
        {
            return SB_ZSXXDAL.GetQueryZD(dtime, strWhere).Tables[0];
        }
    }
}
